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