UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gYEmP9Vwq3fo2O2k0Y0s5nQYkFFoSyzLIH8jimTRR04='
WHERE
key_id = '3de8bc64638a15481d2df181aa7ffba76f5212b2ff2dadd6433d839de63091ec'
AND (
token = 'gYEmP9Vwq3fo2O2k0Y0s5nQYkFFoSyzLIH8jimTRR04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)