UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B9L5+f6D+1aFBbmK98qIS3w8DkaQN7ImkxGNemND6h4='
WHERE
key_id = 'fce7e9538ff4b4751467dcf334a75b7851d40ce1de11ed66f53cab5d06122572'
AND (
token = 'B9L5+f6D+1aFBbmK98qIS3w8DkaQN7ImkxGNemND6h4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)