UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a5z+J/t9A/j1u+uVfUMw+Drm78+yzC6jv4xIFVX3qag='
WHERE
key_id = 'e15194e880028c880d3f11ddb93e5ffdaded811de06024820b827ba0f7b28ac9'
AND (
token = 'a5z+J/t9A/j1u+uVfUMw+Drm78+yzC6jv4xIFVX3qag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)