UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gx8jrSIYo8tgvLmV6OUtFg7rOLLLA4Hphx7VyEEzhGg='
WHERE
key_id = 'b3ddd0464e32800a2ff54cf5f9406490fbc71b125206075c8b9e80de0f3b7a4e'
AND (
token = 'Gx8jrSIYo8tgvLmV6OUtFg7rOLLLA4Hphx7VyEEzhGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)