UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Q/rDeAJnwRi24FCuFDfAsM+0sPfICRW6R5ykR40z4Q='
WHERE
key_id = '4c29fdd285cad962fa7bc131d58846aa0c0e37e4a7a998569bc113577537ab45'
AND (
token = '2Q/rDeAJnwRi24FCuFDfAsM+0sPfICRW6R5ykR40z4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)