UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LKjhGTdHsyspG/f+qpHToEY3mFVrttwW2xdFv3QKh+s='
WHERE
key_id = '81f3f18a14acadd9ebfa2429cc01c8c7fae2511a7be3ae5ff3f17994831eb517'
AND (
token = 'LKjhGTdHsyspG/f+qpHToEY3mFVrttwW2xdFv3QKh+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)