UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9q60OTozJXKIYcobag4o0+b3JjdWagTDjdRAIU8qNcs='
WHERE
key_id = 'bd73b5fed8ae0fa280a9409af734cb7ce425e352d13a6c5d3a4c7f3b831e25a8'
AND (
token = '9q60OTozJXKIYcobag4o0+b3JjdWagTDjdRAIU8qNcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)