UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kpg/lgIMc3fL+2iJUSoUqczAnuBNgsUNTLOWGQw4pg4='
WHERE
key_id = 'c0f6a048f27c30dc0249a92cc42c500b42db8637606a12cafd3fbe4ecdc22fb4'
AND (
token = 'kpg/lgIMc3fL+2iJUSoUqczAnuBNgsUNTLOWGQw4pg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)