UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Goo01FDYvYDtgQZtRLFCIbaPgOwCW6JfZhyZ3WTaCMo='
WHERE
key_id = '45c6c9e82ef5255664e3861de13645fe78aae247e1ac663bccd436cd6212ef1a'
AND (
token = 'Goo01FDYvYDtgQZtRLFCIbaPgOwCW6JfZhyZ3WTaCMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)