UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cd4ydpY+mj7OkavaG1VZALy2gqIDcsNANoIT9j7exrk='
WHERE
key_id = 'd6077078ba25a5087f338d08e201c6707d20b22062f2c8bdbb663063f0bf91f9'
AND (
token = 'cd4ydpY+mj7OkavaG1VZALy2gqIDcsNANoIT9j7exrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)