UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jG4yImcvoaOOHP2gRHnUnrSiB6H0PdoV6abPgYLSE9M='
WHERE
key_id = 'fa0db6a39489569dd78c5097f7f4bff408a307e743e6d881f5e4f550d7feb4c0'
AND (
token = 'jG4yImcvoaOOHP2gRHnUnrSiB6H0PdoV6abPgYLSE9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)