UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RWXFmVwHhtW0ob7pMpihStjYZq1C1JVxkTZdZwJaxmM='
WHERE
key_id = 'c1433eae97d118eaf2de4804640fed335feb48c442052447dcff608ebf57b4aa'
AND (
token = 'RWXFmVwHhtW0ob7pMpihStjYZq1C1JVxkTZdZwJaxmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)