UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'irGR2CP2tNe4vsqGv0ZDYvabV2Z9+dGWMaBet/uruVU='
WHERE
key_id = 'b42790d6f685340576bd494533b13b9088b958bd9fb6c62afcc13b15f1ac4672'
AND (
token = 'irGR2CP2tNe4vsqGv0ZDYvabV2Z9+dGWMaBet/uruVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)