UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J2VhgCRNFZ72DtM+ovyNy9K0KeX0YW3b6A7I0kr5XYs='
WHERE
key_id = '06ed241a6d85e5597dcc74fa12cf72c0bcefffbc55403d8bc087794640283a39'
AND (
token = 'J2VhgCRNFZ72DtM+ovyNy9K0KeX0YW3b6A7I0kr5XYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)