UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xqgTW66p3uX2v/i8PeUEQKX0Crp0sJm5h1Fvast6ERA='
WHERE
key_id = 'd978722b2a2df8de21e714c0438971cacbc0eabdaf13bfc79e760794d52d8392'
AND (
token = 'xqgTW66p3uX2v/i8PeUEQKX0Crp0sJm5h1Fvast6ERA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)