UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'erUb+2yl9rXcJOJBlb6/p4Sn4p4OvNK89oE0FH5ISXo='
WHERE
key_id = 'ebe01a261ede13d2322ef9326bcb797230f559e12e7c3823abe662978dcafbf1'
AND (
token = 'erUb+2yl9rXcJOJBlb6/p4Sn4p4OvNK89oE0FH5ISXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)