UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HkEnKZyA/fLOO+77sMYuDUexdxYJ5d2FeYO3tFQFRxU='
WHERE
key_id = '7fe1437070db6099d41f47c064f6dddca6d4ed3c848616c01d36eb609a2456e0'
AND (
token = 'HkEnKZyA/fLOO+77sMYuDUexdxYJ5d2FeYO3tFQFRxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)