UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D8jJewPEe7a3GyRBJtklLyNaeZquUCKYLrrTlfFCYXk='
WHERE
key_id = '4d0bdd6ceb125f198aa1a854ce446d3fd2824998868a4259b78f549aef7e9a22'
AND (
token = 'D8jJewPEe7a3GyRBJtklLyNaeZquUCKYLrrTlfFCYXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)