UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LgtyKGSqWH334vNEnwXKiA/D+bE25CVRk8bdp9yuWME='
WHERE
key_id = 'aee8978bd02e8bfc9ef1f64cac2a507868a4121d39be6a9753e2e969536dc1c5'
AND (
token = 'LgtyKGSqWH334vNEnwXKiA/D+bE25CVRk8bdp9yuWME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)