UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJageKYRlNFjeNFrKxXA7GSH1NjpE+tZOkKm61fS868='
WHERE
key_id = '528e49ef45d0d59d8842569b6f32a36560cf7a47b75988141f0e0b14c5fbe1b6'
AND (
token = 'DJageKYRlNFjeNFrKxXA7GSH1NjpE+tZOkKm61fS868='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)