UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cFhop0mn/z+pgwFyf7wNDVFrPtISI7zvu0xsocuAgN4='
WHERE
key_id = 'b69070c1119c8e0125c21a11171887583c2c83c53abdc02fae76c75f064eee51'
AND (
token = 'cFhop0mn/z+pgwFyf7wNDVFrPtISI7zvu0xsocuAgN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)