UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oqYxeW+Apbw3EmaDYS42rKrOppKu3rCR8Avg2ggXvkI='
WHERE
key_id = '98c04ca81ce52010b02da65f5621526ddb16941f61634247078961017397098e'
AND (
token = 'oqYxeW+Apbw3EmaDYS42rKrOppKu3rCR8Avg2ggXvkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)