UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VJg5AwuG+EiVYrtPWusFSKllfjiwOizbfKtliDgceaQ='
WHERE
key_id = 'cd773a269cb72c661dcac049e3396380be4f27bacdf4f1210452564deb23dd4a'
AND (
token = 'VJg5AwuG+EiVYrtPWusFSKllfjiwOizbfKtliDgceaQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)