UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNHgsthyk4xTRNlyp/nnnpd/RL9si7/TmKXJI3q7aNw='
WHERE
key_id = 'd7ac0d928dcab88ae49bbdc2823fc9a132b2d8b8ccb2ceb2a36f098c47c70b2d'
AND (
token = 'pNHgsthyk4xTRNlyp/nnnpd/RL9si7/TmKXJI3q7aNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)