UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZMidNSjk3a0LHEqezDRsrgHlKCn9RI8gNfDTfB+HPk='
WHERE
key_id = '9209fe05bfb49d3074cf543bb38799917a8de71bc305ff08eee00e131c2c9d06'
AND (
token = 'zZMidNSjk3a0LHEqezDRsrgHlKCn9RI8gNfDTfB+HPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)