UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gUZL3OCrUybqg9pjTU1cODfTYDcvc7Xx3yYgSeyZ6g='
WHERE
key_id = '10bc17fef040ab6f9ead97e70ab604786b0e3a1f2c4e6c37c524aacc0208871a'
AND (
token = '6gUZL3OCrUybqg9pjTU1cODfTYDcvc7Xx3yYgSeyZ6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)