UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ItcolNAzKxNilL97jtv4ARiLEf+PJjX/4wxHGfdMfc8='
WHERE
key_id = '4ee8280750db0f83c02e9382c1d0c5f37f7ce84d183b1ca7119bad8b1f34b650'
AND (
token = 'ItcolNAzKxNilL97jtv4ARiLEf+PJjX/4wxHGfdMfc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)