UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TjHI6Ut7Vo0uY7hQKTpMuR4DvRyhu7ngF6CJd14FbfU='
WHERE
key_id = '2107e66d0133febf9765012cea8ba83a7fcf2661ed2475619faa94bdf4f6aa00'
AND (
token = 'TjHI6Ut7Vo0uY7hQKTpMuR4DvRyhu7ngF6CJd14FbfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)