UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '10RfI2S3iSWkOJaeADd6jEm2QC/5Gh7A9yrDm+Fserk='
WHERE
key_id = 'b9054cd9b55104bee97a75cbdfe58cfc2c42a53e2107da1492dc5f203b70005f'
AND (
token = '10RfI2S3iSWkOJaeADd6jEm2QC/5Gh7A9yrDm+Fserk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)